Release 10.1A: OpenEdge Development:
Progress Dynamics Administration

Sequence Maintenance window

The Sequence Maintenance folder window, shown in Figure 4–2, allows for editing of all the fields for a sequence.

Figure 4–2: Sequence Maintenance window

The Sequence TLA field refers to a unique three-letter-acronym which, in conjunction with the Entity Mnemonic field, forms the composite key. Thus, each mnemonic can have multiple sequences.

The Sequence format field contains a user-defined format mask for the sequence. The format mask must include a numeric format that allows for the maximum value and that conforms to the database format rules (for example: 99999999 = eight-digit number with 0 prefix).

The format can include hard-coded characters (for example PO for purchase order). The format can also include insertion codes to dynamically insert data at run time, as follows:

%Y = Insert the last digit of the current year.
%YY = Insert the current two-digit year.
%YYYY = Insert the current four-digit year.
%MM = Insert the current two-digit month.
%MMM = Insert the current three-character month.
%DD = Insert the current day of the month.